Description: Excel spreadsheet showing immediate annuity example of GAAP benefit reserves and Unearned Revenue Liability calculation from the U.S. GAAP & IFRS: Today and Tomorrow conference in New York in September of 2010.

Description: Excel spreadsheet example of GAAP calculations for an immediate annuity showing benefit reserves, DAC, and Unearned Revenue Liability [URL] from the 2010 U.S. GAAP & IFRS conference in New York.

Description: Excel spreadsheet showing a FAS 133 numeric example from this session of the 2010 U.S. GAAP & IFRS conference held in New YorkProduct.

Description: Excel spreadsheet example of GAAP calculations for a Universal life plan showing reserves and DAC under FAS97 . Also shown is an unlocking example from this session of the 2010 U.S GAAP & IFRS conference in New York.

Description: Authored by a MIB Solutions team of Tom Rhodes, Stuart Klugman, Marianne Purushotham and Stacy Gill, the report summarizes the results of a study on the application and adoption of credibility theory within the life insurance and annuity industry. In addition to the report, numerical examples related to the application of credibility to company mortality and lapse data are provided in the four Excel files. This excel spreadsheet is a numerical example relating to the application of Credibility for mortality - Limited Fluctuation Method. Please see the SOA website research section for the full report on Credibity Theory Practices.

Description: Authored by a MIB Solutions team of Tom Rhodes, Stuart Klugman, Marianne Purushotham and Stacy Gill, the report summarizes the results of a study on the application and adoption of credibility theory within the life insurance and annuity industry. In addition to the report, numerical examples related to the application of credibility to company mortality and lapse data are provided in the four Excel files. This excel spreadsheet is a numerical example relating to the application of Credibility for mortality. Please see the SOA website research section for the complete report on Credibility Theory Practices.

Description: This is the mortality tables that appear in the 2000-2004 Preneed Insurance Mortality Study report. Please see the SOA website for the complete report.

Description: Authored by a MIB Solutions team of Tom Rhodes, Stuart Klugman, Marianne Purushotham and Stacy Gill, the report summarizes the results of a study on the application and adoption of credibility theory within the life insurance and annuity industry. In addition to the report, numerical examples related to the application of credibility to company mortality and lapse data are provided in the four Excel files. This excel spreadsheet is a numerical example relating to the application of Credibility for lapses by policy for limited fluctuation. Please see the SOA website research section for the full report on Credibility Theory Practices.

Description: The Group Life Insurance Experience Committee of the Society of Actuaries has completed the 2005 Group Term Life Waiver Reserve Table Report. There were several compelling reasons to develop a new experience study and table, not the least of which was that 35 years is a long interval for any study. This is the excel Calculation Spreadsheet for Reserve Factors for Group Term Waiver of Premium [NAIC version]. Please see the SOA website for the Report of the Group Life Experience Committee for March 2006.

Description: The Required Minimum Distribution [RMD] Working Group of the SOA Taxation Section has completed research identifying considerations for actuaries and annuity insurers in determing the actuarial present value of additional benefits for computing the RMD under a deferred annuity contract. This is the Appendix I spreadsheet for determining the Actuarial Present Value of an annuitization bonus. Please see the SOA website research for the full report and other associated spreadsheets.